package com.bw.dao;

import com.bw.bean.Trafficbean;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @projectName: SpringBoot1
 * @fileName: TrafficDao
 * @packageName: com.bw.dao
 * @date: 2025/9/18 10:02
 * @author: ymw
 */
@Mapper
public interface TrafficDao {
//    @Select("select\n" +
//            "    ch,\n" +
//            "    sum(uvCt) as uv_cts,\n" +
//            "    sum(pvCt) as pv_cts,\n" +
//            "    sum(durSum) as dur_sums,\n" +
//            "    sum(ujCt) as ujv_cts,\n" +
//            "     sum(svCt) as svCts\n" +
//            "from dws_traffic_vc_ch_page_window\n" +
//            "where toYYYYMMDD(stt)=#{date}\n" +
//            "group by ch")
     List<Trafficbean> traffic(int  date);
}
